﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Sasc.PV.BLL;
using Sasc.PV.DAL;

namespace Sasc.PV.Web.Admin
{
    public partial class SelectCondition : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

                DataBindToGridview();
            }
        }
        //查询
        protected void ImageButton4_Click(object sender, ImageClickEventArgs e)
        {
            DataBindToGridview();

        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            this.GridView1.PageIndex = e.NewPageIndex;
            DataBindToGridview();
        }

        public string GetTypeStr()
        {
            try
            {
                if (Request.QueryString["GetType"].ToString() == "My")
                {
                    return " and UserName='" + PublicMethod.GetSessionValue("UserName") + "' ";
                }
                else
                {
                    return "";
                }
            }
            catch
            {
                return "";
            }
        }
        public void DataBindToGridview()
        {
            try
            {
                string GetTable = Request.QueryString["GetTable"].ToString();
                BindGridView("select CanShuName as SelectContent from " + GetTable + " where TableName='" + Request.QueryString["TableName"].ToString() + "'  and LieName='" + Request.QueryString["LieName"].ToString() + "' and CanShuName like '%" + this.TextBox1.Text + "%' " + GetTypeStr(), this.GridView1);
            }
            catch
            {
                BindGridView("select distinct " + Request.QueryString["LieName"].ToString() + " as SelectContent from " + Request.QueryString["TableName"].ToString() + " where " + Request.QueryString["LieName"].ToString() + " like '%" + this.TextBox1.Text + "%' " + GetTypeStr(), this.GridView1);
            }
        }


        //绑定到GridView
        public static void BindGridView(string SqlString, GridView MyGvData)
        {
            MyGvData.DataSource = DbHelperSQL.GetDataSet(SqlString);
            MyGvData.DataBind();
        }


    }
}